🔍 Query Optimization - widget101 · Scour

Ace Your SQL Interview, Part 2: Querying Like a Pro ⚙️Database Internals

betterengineers.substack.com·1d·r/programming·

new world: writing complex queries in seconds 🧮Apache Calcite

alodb.com·4d·r/programming·

ProjectASAP/ASAPQuery: Drop-in Acceleration of SQL/PromQL queries 🧮Apache Calcite

github.com·10h·Hacker News·

B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything 🗃️Database Storage

dev.to·4h·DEV·

Show HN: An Interactive Text to SQL Agent Benchmark 📊Columnar Engines

sql-benchmark.nicklothian.com·2d·Hacker News·

Database Performance Bottlenecks: N+1 Queries, Missing Indexes, and Connection Pools ⚙️Database Internals

howtocenterdiv.com·6d·Hacker News, r/coding, r/programming·

Vector Databases Explained in 3 Levels of Difficulty 🧭Vector Databases

machinelearningmastery.com·6d·Hacker News·

The reason your pgvector benchmark is lying to you 📊Columnar Engines

thenewstack.io·5d·

Debugging PostgreSQL Query Plan Instability in Production 📊Column Stores

dev.to·1d·DEV·

Understanding Data Modelling in Power BI: Joins, Relationships, and Schemas Explained 📐Data Modeling

docs.google.com·3d·DEV·

Architecting for Speed: Advanced SQL Performance Tuning in the Lakehouse 🏛️Lakehouse Architecture

hackernoon.com·6d·

GA4 Data Quality Monitoring with BigQuery SQL ⏱️Real-time Analytics

paolobietolini.com·4d·

Dux: Distributed DuckDB-native DataFrames for Elixir 🌟spark

dux.now·4d·Hacker News·

Building a Production‑Ready SQL Evaluation Engine with Grok 🌟spark

dev.to·2d·DEV·

Hybrid Search System, glue included 🧮Apache Calcite

amgix.io·3d·Hacker News·

Why We're Building a Different Type of Web Index for AI Agents 🔍AI Detection

newscatcherapi.com·6d·Hacker News·

A database toolkit with auditable schema versioning 🧊Iceberg Tables

chameleondb.dev·3d·Hacker News·

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained 📐Data Modeling

dev.to·18h·DEV·

PostgreSQL Row-Level Security for Multi-Tenant SaaS 🛡️Memory Safety

dev.to·14h·DEV·

How to Break Your PostgreSQL IIoT Database and Learn Something in the Process 💾Databases

hackernoon.com·6d·

Loading more...